<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="${viewModule.viewPacking}.mapper.${entityName}Mapper">

    <delete id="deleteByMainId" parameterType="java.lang.String">
        DELETE
        FROM  ${viewModule.viewMaintable}
        WHERE
        ${fk} = ${r'#'}{mainId} <#rt/>
    </delete>



    <select id="selectByMainId" parameterType="java.lang.String" resultType="${viewModule.viewPacking}.entity.${entityName}">
        SELECT *
        FROM  ${viewModule.viewMaintable}
        WHERE
        ${fk} = ${r'#'}{mainId} <#rt/>
    </select>


</mapper>